Skip to content

Instantly share code, notes, and snippets.

Discover gists

@Serganbus
Serganbus / шпаргалка по psql.txt
Last active March 30, 2026 15:17
шпаргалка по psql
Полезные ключи программы psql
-U - Указываем пользователя, например postgres
-W - Приглашение на ввод пароля
-d название_БД - Подключение к БД название_БД
-h имя_хоста - Подключение к хосту имя_хоста
-p порт - По какому порту постгря ожидает подключения
-c команда - Выполнение команды SQL без выхода в интерактивный режим
-f file.sql - Выполнение команд из файла file.sql
-S - Однострочный режим, то есть, переход на новую строку будет выполнять запрос (избавляет от ; в конце конструкции SQL)
@JBlond
JBlond / bash-colors.md
Last active March 30, 2026 15:17 — forked from iamnewton/bash-colors.md
The entire table of ANSI color codes.

Regular Colors

Value Color
\e[0;30m Black
\e[0;31m Red
\e[0;32m Green
\e[0;33m Yellow
\e[0;34m Blue
\e[0;35m Purple
@andriyudatama
andriyudatama / VS Code Disable GPU Acceleration
Last active March 30, 2026 15:15
Disable Hardware Acceleration (GPU) on Visual Studio Code
Visual Studio Code frequently crashes linux. Using NVIDIA GPU
1. Open command pallete (Ctrl + Shift + P)
2. Enter "Preferences: Configure Runtime Arguments"
3. Add config: "disable-hardware-acceleration": true
4. Restart VS Code
@WebLenn
WebLenn / posteio-dokploy-ssl-sync.md
Last active March 30, 2026 15:15

Solving Poste.io SSL/TLS Issues on Dokploy (Traefik) by Syncing Certs from acme.json

I’m sharing this guide because I spent a lot of time troubleshooting SSL errors while setting up Poste.io behind Dokploy. If you are using Dokploy, you likely noticed that the Let's Encrypt certificates managed by Traefik work perfectly for the web dashboard but aren't automatically applied to the mail server ports (25, 587, 993, 995, etc.). This leads to "SSL/TLS Handshake" errors in external clients like Gmail or Outlook.

The Problem

When trying to generate certificates inside Poste.io itself using the built-in Let's Encrypt client, I constantly hit this error: LEScript.ERROR: 400 ... Unable to update challenge :: authorization must be pending

The Solution: "Reverse Sync"

Instead of forcing Poste.io to get its own certificate, this method "feeds" Dokploy's existing certificates into the Poste.io container. This ensures that the Full Chain (Leaf + Intermediate certificates) is present, which is r

@joshbuchea
joshbuchea / semantic-commit-messages.md
Last active March 30, 2026 15:15
Semantic Commit Messages

Semantic Commit Messages

See how a minor change to your commit message style can make you a better programmer.

Format: <type>(<scope>): <subject>

<scope> is optional

Example

@bobrik
bobrik / README.md
Last active March 30, 2026 15:12
Calls into skb:kfree_skb
@docularxu
docularxu / blog-claude-code-china-zh.md
Last active March 30, 2026 15:10
在中国使用 Claude Code 解决 403 错误 - 完整指南（中文版）

在中国使用 Claude Code 解决 403 错误 - 完整指南（中文版）

在中国使用 Claude Code 解决 403 错误

2026 年 2 月 12 日

如果你在中国尝试使用 Claude Code，大概率会撞上 403 错误。本文覆盖三种使用场景的解决方案：

  • macOS 终端 (shell) - 在终端里直接使用 claude 命令行
  • VS Code 终端 - 在 VS Code 内置终端里使用 claude 命令行
@AntonFriberg
AntonFriberg / README.md
Last active March 30, 2026 15:10
How to install and configure a basic Hyprland setup on Ubuntu 24.04 using Nix and Home Manager

Hyprland on Ubuntu 24.04

Hyprland is not available by default on Ubuntu 24.04 so instead we can utilize the Nix package manager and Home Manager.

Nix

The benefit of the Nix package manager compared to others in this case is that the package and dependencies of Nix packages is immutable and self contained. This means that the entire setup is contained to a separate /nix

@bdebon
bdebon / rodin.md
Created March 18, 2026 15:32
Rodin – Interlocuteur socratique pour discussions sociétales profondes — anti-chambre d'écho
name rodin
description Interlocuteur socratique pour discussions sociétales profondes — anti-chambre d'écho

Tu es Rodin, un interlocuteur intellectuel exigeant. Tu incarnes ce rôle pour toute la durée de la conversation. Ne brise jamais le personnage.

Activation

  1. Lis et intègre la synthèse portrait du portrait de l'utilisateur : [OPTIONEL A FAIRE DE VOTRE COTÉ] — c'est ton contexte permanent sur ton interlocuteur. Ne la résume pas, ne la mentionne pas. Intègre-la silencieusement.
@productdevbook
productdevbook / drizzle-orm.md
Last active March 30, 2026 15:09
Drizzle ORM PostgreSQL Best Practices Guide (2025)

Drizzle ORM PostgreSQL Best Practices Guide (2025)

Latest Drizzle ORM features and optimal schema patterns

Major 2025 Update: PostgreSQL now recommends identity columns over serial types. Drizzle has fully embraced this change.

import { pgTable, integer, text, timestamp, varchar } from 'drizzle-orm/pg-core';